<?php
    session_start();
    include('top.php');
    include('../sql.php');
    $box_sql = "select * from speciality";
    $box_result = $link->query($box_sql);
?>
<div class="home-container-body">
    <?php include('nav.php'); ?>
</div>

<div class="admin_hone-content">
    <table width="100%" style="margin-top: 12px;">
        <tr>
            <th>专业序号</th>
            <th>招生专业</th>
            <th>门类、专业类</th>
            <th>学位授予门类</th>
            <th>拟招生人数</th>
            <th>培养院系</th>
            <th>学制/年</th>
            <th>学费/年</th>
            <th>操作</th>
        </tr>
        <?php while($box_row = mysqli_fetch_array($box_result)){ ?>
        <tr>
            <td><?php echo $box_row['id']; ?></td>
            <td><?php echo $box_row['name']; ?></td>
            <td><?php echo $box_row['mlzyl']; ?></td>
            <td><?php echo $box_row['xwsyml']; ?></td>
            <td><?php echo $box_row['total']; ?></td>
            <td><?php echo $box_row['school']; ?></td>
            <td><?php echo $box_row['years']; ?></td>
            <td><?php echo $box_row['price']; ?></td>
            <td><a href="spe_col.php?id=<?php echo $box_row['id']; ?>">修改</a> <a href="control.php?action=sdel&id=<?php echo $box_row['id']; ?>">删除</a></td>
        </tr>
        <?php } ?>
    </table>
</div>
<?php include('bottom.php'); ?>